----------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\research\china\decentralization\restat_data\tabdata\dofiles\tab_da
> ta\tabdata5.log
  log type:  text
 opened on:  22 Jul 2016, 09:51:25

. 
. 
. ************************ 1. Prepare various tabular sources for merging ********
> *************************
. 
. use ..\..\data\tabular_data_BJ\source\ind_yb_rz.dta

. ***Fix these unit_status which are wrong
. replace unit_status=5 if unit_code_08==130200 & year==1995
(1 real change made)

. replace unit_status=5 if unit_code_08==130200 & year==2000
(0 real changes made)

. replace unit_status=5 if unit_code_08==130200 & year==2005
(0 real changes made)

. replace unit_status=4 if unit_code_08==130201 & year==1995
(1 real change made)

. replace unit_status=4 if unit_code_08==130201 & year==2000
(0 real changes made)

. replace unit_status=4 if unit_code_08==130201 & year==2005
(0 real changes made)

. replace unit_status=5 if unit_code_08==130400 & year==1995
(0 real changes made)

. replace unit_status=4 if unit_code_08==130401 & year==1995
(0 real changes made)

. replace unit_status=5 if unit_code_08==510300 & year==2000
(0 real changes made)

. replace unit_status=4 if unit_code_08==510301 & year==2000
(0 real changes made)

. keep if unit_status==5
(4,022 observations deleted)

. rename unit_code_08 city_code

. sort city_code year

. save temp_indyb.dta, replace
(note: file temp_indyb.dta not found)
file temp_indyb.dta saved

. 
. use ..\..\data\tabular_data_BJ\source\PY_2YCP_final_rz.dta

. sort unit_code year 

. merge unit_code year using ..\..\data\tabular_data_BJ\source\PY_ADCP_final_rz.dt
> a, update
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          2 |      1,986       66.67       66.67
          3 |        993       33.33      100.00
------------+-----------------------------------
      Total |      2,979      100.00

. drop _merge

. keep if year==1990|year==1995
(2,317 observations deleted)

. gen city_code = unit_code

. replace city_code = unit_code-100 if city_code-10*int(city_code/10)==0
(8 real changes made)

. replace city_code = unit_code-1 if city_code-10*int(city_code/10)==1
(654 real changes made)

. keep city_code year total_pop gdp

. rename total_pop total_pop_cp

. rename gdp gdp_py_cp

. sort city_code year

. save temp_2ycp.dta, replace
(note: file temp_2ycp.dta not found)
file temp_2ycp.dta saved

. use ..\..\data\tabular_data_BJ\source\PY_ADPF_final_rz.dta

. sort unit_code year

. save ..\..\data\tabular_data_BJ\source\PY_ADPF_final_rz.dta, replace
file ..\..\data\tabular_data_BJ\source\PY_ADPF_final_rz.dta saved

. use ..\..\data\tabular_data_BJ\source\PY_2YPF_final_rz.dta

. sort unit_code year 

. merge unit_code year using ..\..\data\tabular_data_BJ\source\PY_ADPF_final_rz.dt
> a, update
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          2 |      1,986       66.67       66.67
          3 |        993       33.33      100.00
------------+-----------------------------------
      Total |      2,979      100.00

. drop _merge

. keep if year==1990|year==1995
(2,317 observations deleted)

. rename unit_code city_code

. rename gdp gdp_py

. *** Drop obs that clearly have cp level data instead
. sort city_code year

. merge city_code year using temp_2ycp.dta
(note: you are using old merge syntax; see [D] merge for new syntax)
(note: variable city_code was long, now double to accommodate using data's
       values)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          3 |        662      100.00      100.00
------------+-----------------------------------
      Total |        662      100.00

. drop _merge

. drop if total_pop==total_pop_cp
(298 observations deleted)

. drop if total_pop==-9 & gdp_py==-9
(12 observations deleted)

. drop total_pop_cp gdp_py_cp

. sort city_code year

. save temp_2ypf.dta, replace
(note: file temp_2ypf.dta not found)
file temp_2ypf.dta saved

. erase temp_2ycp.dta

. 
. use ..\..\data\tabular_data_BJ\source\MI_4YPF.dta

. rename gdp gdp_michigan

. rename gdp_sector2 gdp_sector2_mi

. rename gdp_sector3 gdp_sector3_mi

. rename total_pop pop

. sort city_code year

. save temp_mi3ypf.dta, replace
(note: file temp_mi3ypf.dta not found)
file temp_mi3ypf.dta saved

. 
. use ..\..\data\tabular_data_BJ\source\MI_ADPF.dta

. sort city_code year

. save ..\..\data\tabular_data_BJ\source\MI_ADPF.dta, replace
file ..\..\data\tabular_data_BJ\source\MI_ADPF.dta saved

. 
. 
. ** Professor Zhang's dijishi.csv (HY 08/09/12)
. 
. insheet using ..\..\data\tabular_data_BJ\source\asset_dijishi.csv, clear
(14 vars, 858 obs)

. *** Drop Obs in which CP numbers are filled in for prefs
. drop if net_asset_pref<=net_asset_cp & year==1990 & (city05~=420700 & city05==62
> 0200 & city05~=441900 & city05~=442000)
(1 observation deleted)

. drop gross_asset_cp net_asset_cp

. rename city_name city_namex

. rename city05 city_code

. rename gross_asset_pref asset_g_qz

. rename net_asset_pref asset_n_qz

. save temp_qz4.dta, replace
(note: file temp_qz4.dta not found)
file temp_qz4.dta saved

. insheet using ..\..\data\tabular_data_BJ\source\assets_05.csv, clear
(7 vars, 286 obs)

. *** These are all CP numbers
. drop net_asset_cp

. rename city_name city_namex

. rename city05 city_code

. rename net_asset_pref asset_n_qz

. append using temp_qz4

. sort city_code year

. save temp_qz4.dta, replace
file temp_qz4.dta saved

. 
. 
. ******* 2. Save data for counties that switched prefectures ***********
. 
. use ..\..\data\tabular_data_BJ\generated\us123-census.dta

. egen md05 = mode(city05), by(city_code year) minmode

. keep if city05~=md05
(16,768 observations deleted)

. keep city_code city05 year a434-expval a101-a874 gdp_predf gdp_predc gdp_sect2_p
> redf gdp_sect2_predc culland

. ***This is the addition data set
. save temp_us123.dta, replace
(note: file temp_us123.dta not found)
file temp_us123.dta saved

. 
. ***Make a subtraction data set
. foreach X of varlist a434-expval a101-a874 culland {
  2.    replace `X' = -`X'
  3. }
(102 real changes made)
(102 real changes made)
(102 real changes made)
(0 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(0 real changes made)
(0 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(0 real changes made)
(102 real changes made)
(102 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(2 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(1 real change made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(11 real changes made)
(11 real changes made)
(1 real change made)
(1 real change made)
(12 real changes made)
(13 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
(0 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(4 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(44 real changes made)
(44 real changes made)
(44 real changes made)
(44 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(101 real changes made)
(101 real changes made)
(101 real changes made)
(101 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(93 real changes made)
(89 real changes made)
(89 real changes made)
(78 real changes made)
(50 real changes made)
(73 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(68 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(84 real changes made)
(82 real changes made)
(53 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(101 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(64 real changes made)
(60 real changes made)
(43 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(81 real changes made)
(78 real changes made)
(74 real changes made)
(102 real changes made)
(102 real changes made)
(102 real changes made)
(83 real changes made)
(73 real changes made)
(79 real changes made)
(100 real changes made)
(97 real changes made)
(95 real changes made)
(75 real changes made)
(46 real changes made)
(69 real changes made)
(39 real changes made)
(20 real changes made)
(38 real changes made)
(95 real changes made)
(82 real changes made)
(95 real changes made)
(84 real changes made)
(65 real changes made)
(80 real changes made)
(96 real changes made)
(92 real changes made)
(95 real changes made)
(74 real changes made)
(52 real changes made)
(66 real changes made)
(72 real changes made)
(58 real changes made)
(66 real changes made)
(97 real changes made)
(94 real changes made)
(94 real changes made)
(73 real changes made)
(50 real changes made)
(71 real changes made)
(68 real changes made)
(52 real changes made)
(61 real changes made)
(62 real changes made)
(43 real changes made)
(60 real changes made)
(84 real changes made)
(74 real changes made)
(77 real changes made)
(36 real changes made)
(13 real changes made)
(36 real changes made)
(8 real changes made)
(2 real changes made)
(7 real changes made)
(44 real changes made)
(24 real changes made)
(43 real changes made)
(62 real changes made)
(33 real changes made)
(59 real changes made)
(27 real changes made)
(10 real changes made)
(25 real changes made)
(25 real changes made)
(10 real changes made)
(25 real changes made)
(29 real changes made)
(20 real changes made)
(25 real changes made)
(23 real changes made)
(10 real changes made)
(22 real changes made)
(27 real changes made)
(9 real changes made)
(27 real changes made)
(44 real changes made)
(26 real changes made)
(42 real changes made)
(15 real changes made)
(7 real changes made)
(13 real changes made)
(21 real changes made)
(11 real changes made)
(21 real changes made)
(4 real changes made)
(1 real change made)
(4 real changes made)
(3 real changes made)
(1 real change made)
(3 real changes made)
(32 real changes made)
(16 real changes made)
(28 real changes made)
(24 real changes made)
(19 real changes made)
(21 real changes made)
(26 real changes made)
(17 real changes made)
(25 real changes made)
(20 real changes made)
(13 real changes made)
(19 real changes made)
(16 real changes made)
(7 real changes made)
(15 real changes made)
(8 real changes made)
(1 real change made)
(7 real changes made)
(27 real changes made)
(15 real changes made)
(25 real changes made)
(23 real changes made)
(13 real changes made)
(20 real changes made)
(37 real changes made)
(29 real changes made)
(37 real changes made)
(5 real changes made)
(0 real changes made)
(5 real changes made)
(9 real changes made)
(2 real changes made)
(8 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(9 real changes made)
(1 real change made)
(9 real changes made)
(2 real changes made)
(0 real changes made)
(2 real changes made)
(9 real changes made)
(5 real changes made)
(8 real changes made)
(7 real changes made)
(6 real changes made)
(7 real changes made)
(4 real changes made)
(0 real changes made)
(4 real changes made)
(2 real changes made)
(1 real change made)
(2 real changes made)
(3 real changes made)
(2 real changes made)
(3 real changes made)
(34 real changes made)
(17 real changes made)
(30 real changes made)
(2 real changes made)
(1 real change made)
(1 real change made)
(12 real changes made)
(3 real changes made)
(10 real changes made)
(16 real changes made)
(14 real changes made)
(13 real changes made)
(11 real changes made)
(6 real changes made)
(11 real changes made)
(2 real changes made)
(1 real change made)
(1 real change made)
(2 real changes made)
(0 real changes made)
(2 real changes made)
(3 real changes made)
(1 real change made)
(3 real changes made)
(34 real changes made)
(23 real changes made)
(33 real changes made)
(28 real changes made)
(6 real changes made)
(28 real changes made)
(99 real changes made)

. drop city05

. save temp2_us123.dta, replace
(note: file temp2_us123.dta not found)
file temp2_us123.dta saved

. 
. 
. /****** 3. Merge Data Sets to Correspondence Table Using 
>                                         Prefecture/Year Units Only ********/
. 
. *** Create a data set of prefecture/year
. use ..\..\data\tabular_data_BJ\generated\us123-census.dta

. keep province_name province_code city_code city_name year city05

. egen md05 = mode(city05), by(city_code year) minmode

. keep if city05==md05
(451 observations deleted)

. sort city_code year

. by city_code year: keep if _n==1
(14,809 observations deleted)

. sort city_code year

. 
. *** Individual Yearbook
. merge city_code year using temp_indyb.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab year _merge

           |        _merge
      year |         1          3 |     Total
-----------+----------------------+----------
      1982 |       246          0 |       246 
      1990 |       258         30 |       288 
      1995 |       231         51 |       282 
      2000 |       191         94 |       285 
      2005 |       180        106 |       286 
      2008 |       217         69 |       286 
      2010 |       286          0 |       286 
-----------+----------------------+----------
     Total |     1,609        350 |     1,959 


. rename _merge mrg_ind

. 
. *** Michigan
. sort city_code year

. merge city_code year using temp_mi3ypf.dta
(note: you are using old merge syntax; see [D] merge for new syntax)
(note: variable unit_status was byte, now float to accommodate using data's
       values)

. tab year _merge

           |        _merge
      year |         1          3 |     Total
-----------+----------------------+----------
      1982 |       246          0 |       246 
      1990 |       288          0 |       288 
      1995 |       282          0 |       282 
      2000 |        18        267 |       285 
      2005 |        16        270 |       286 
      2008 |        16        270 |       286 
      2010 |        16        270 |       286 
-----------+----------------------+----------
     Total |       882      1,077 |     1,959 


. 
. ** These are the prefectures we dropped
. drop if _merge==2
(0 observations deleted)

. rename _merge mrg_MI3Y

. 
. *** Printed Yearbooks
. sort city_code year

. merge city_code year using temp_2ypf.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab year _merge

           |              _merge
      year |         1          2          3 |     Total
-----------+---------------------------------+----------
      1982 |       246          0          0 |       246 
      1990 |       128          2        160 |       290 
      1995 |        94          2        188 |       284 
      2000 |       285          0          0 |       285 
      2005 |       286          0          0 |       286 
      2008 |       286          0          0 |       286 
      2010 |       286          0          0 |       286 
-----------+---------------------------------+----------
     Total |     1,611          4        348 |     1,963 


. ** These are the prefectures we dropped
. drop if _merge==2
(4 observations deleted)

. rename _merge mrg_PY2Y

. 
. *** Annual Michigan Data
. sort city_code year

. merge city_code year using ..\..\data\tabular_data_BJ\source\MI_ADPF.dta
(note: you are using old merge syntax; see [D] merge for new syntax)
(note: variable province was str12, now str14 to accommodate using data's
       values)
(note: variable fdi was long, now double to accommodate using data's values)

. tab year _merge

           |              _merge
      year |         1          2          3 |     Total
-----------+---------------------------------+----------
      1982 |       246          0          0 |       246 
      1990 |       288          0          0 |       288 
      1995 |       282          0          0 |       282 
      1996 |         0        207          0 |       207 
      1997 |         0        214          0 |       214 
      1998 |         0        219          0 |       219 
      1999 |         0        226          0 |       226 
      2000 |        35          0        250 |       285 
      2001 |         0        254          0 |       254 
      2002 |         0        264          0 |       264 
      2003 |         0        269          0 |       269 
      2004 |         0        270          0 |       270 
      2005 |        16          0        270 |       286 
      2006 |         0        270          0 |       270 
      2007 |         0        270          0 |       270 
      2008 |        16          0        270 |       286 
      2009 |         0        270          0 |       270 
      2010 |        16          0        270 |       286 
-----------+---------------------------------+----------
     Total |       899      2,733      1,060 |     4,692 


. ** These are off-years & dropped prefectures
. drop if _merge==2
(2,733 observations deleted)

. rename _merge mrg_MIAD

. 
. *** Census Data
. sort city_code year

. merge city_code year using ..\..\data\census\generated\pf90.dta, update replace
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge if year==1990

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          2 |         56       16.28       16.28
          3 |        288       83.72      100.00
------------+-----------------------------------
      Total |        344      100.00

. *These are prefectures outside of our study area
. drop if _merge==2
(56 observations deleted)

. rename _merge mrg_cen

. drop mrg_*

. rename avg_salary_of_staff_worker sal_staffwork

. rename no_of_college_students college_stu

. rename area_paved_roads area_pvdrd

. rename paved_roads_percap pvdrd_percap

. rename count_buses_trolleys bus_trol

. rename so2_tons_year_km s02_tonyrkm

. rename tot_fixed_invest tot_fixinv

. 
. ** Professor Zhang's dijishi.csv (HY 08/09/12)
. 
. sort city_code year

. merge city_code year using temp_qz4.dta
(note: you are using old merge syntax; see [D] merge for new syntax)
(note: variable unit_code_08 was float, now double to accommodate using data's
       values)

. tab year _merge

           |              _merge
      year |         1          2          3 |     Total
-----------+---------------------------------+----------
      1982 |       246          0          0 |       246 
      1990 |       100         97        188 |       385 
      1995 |       282          0          0 |       282 
      2000 |        19         20        266 |       305 
      2005 |         0          0        286 |       286 
      2008 |       286          0          0 |       286 
      2010 |         0          0        286 |       286 
-----------+---------------------------------+----------
     Total |       933        117      1,026 |     2,076 


. drop if _merge==2
(117 observations deleted)

. rename _merge mrg_QZ4

. 
. mvdecode totemp-fdi, mv(-9)
      gdp_py: 1 missing value generated
   gdp_sect2: 1 missing value generated
   gdp_sect3: 1 missing value generated
        kmpr: 348 missing values generated
         apr: 348 missing values generated
        prpc: 348 missing values generated
      num_bt: 348 missing values generated
   avgsalary: 160 missing values generated
  num_colstd: 44 missing values generated
    givo_soe: 188 missing values generated
   givo_colt: 188 missing values generated
     exp_lgt: 1 missing value generated
    num_hedu: 26 missing values generated
         fdi: 35 missing values generated

. drop province unit nmcenmq

. 
. /** Deal with prefecture boundary changes: subtract units that moved 
> from city_code to city05 and then add them to city05 **/
. append using temp2_us123.dta
(note: variable gdp_sector2 was float, now double to accommodate using data's
       values)
(note: variable gdp_sector3 was float, now double to accommodate using data's
       values)
(note: variable culland was int, now float to accommodate using data's values)

. /*** Set all obs of variables to . if do not populate 
>                         all obs within groups. *****/
. sort city_code year city05

. by city_code year: replace city05 = city05[1] if city05==.
(451 real changes made)

. by city_code year: gen obs = _N

. 
. foreach X of varlist gdp-a874 asset_g_qz asset_n_qz {
  2.    egen varcount = count(`X'), by(city_code city05 year)
  3.    replace `X' = . if varcount<obs
  4.    drop varcount
  5. }
(1 real change made, 1 to missing)
(0 real changes made)
(1 real change made, 1 to missing)
(0 real changes made)
(1 real change made, 1 to missing)
(0 real changes made)
(1 real change made, 1 to missing)
(0 real changes made)
(2 real changes made, 2 to missing)
(3 real changes made, 3 to missing)
(0 real changes made)
(1 real change made, 1 to missing)
(0 real changes made)
(1 real change made, 1 to missing)
(0 real changes made)
(2 real changes made, 2 to missing)
(1 real change made, 1 to missing)
(0 real changes made)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(12 real changes made, 12 to missing)
(9 real changes made, 9 to missing)
(2 real changes made, 2 to missing)
(2 real changes made, 2 to missing)
(2 real changes made, 2 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(2 real changes made, 2 to missing)
(2 real changes made, 2 to missing)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(3 real changes made, 3 to missing)
(0 real changes made)
(19 real changes made, 19 to missing)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(19 real changes made, 19 to missing)
(19 real changes made, 19 to missing)
(19 real changes made, 19 to missing)
(19 real changes made, 19 to missing)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(3 real changes made, 3 to missing)
(19 real changes made, 19 to missing)
(16 real changes made, 16 to missing)
(16 real changes made, 16 to missing)
(16 real changes made, 16 to missing)
(16 real changes made, 16 to missing)
(16 real changes made, 16 to missing)
(62 real changes made, 62 to missing)
(16 real changes made, 16 to missing)
(19 real changes made, 19 to missing)
(19 real changes made, 19 to missing)
(19 real changes made, 19 to missing)
(19 real changes made, 19 to missing)
(2 real changes made, 2 to missing)
(37 real changes made, 37 to missing)
(37 real changes made, 37 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(15 real changes made, 15 to missing)
(17 real changes made, 17 to missing)

. 
. collapse (sum) gdp-a874 asset_g_qz asset_n_qz, by(city_code city05 year)

. 
. *** Set all 0s to .
. mvdecode gdp-a874 asset_g_qz asset_n_qz, mv(0)
         gdp: 1657 missing values generated
         nnp: 1956 missing values generated
 gdp_sector1: 1715 missing values generated
 nnp_sector1: 1947 missing values generated
 gdp_sector2: 1673 missing values generated
 nnp_sector2: 1939 missing values generated
 gdp_sector3: 1673 missing values generated
 nnp_sector3: 1939 missing values generated
     tot_pop: 1656 missing values generated
     r08_gdp: 1775 missing values generated
     r08_nnp: 1958 missing values generated
r08_gdp_se~2: 1780 missing values generated
r08_nnp_se~2: 1954 missing values generated
r08_gdp_se~3: 1780 missing values generated
r08_nnp_se~3: 1954 missing values generated
 r08_tot_pop: 1790 missing values generated
     num_car: 1766 missing values generated
    dust_ems: 1760 missing values generated
     gas_ems: 1735 missing values generated
         so2: 1749 missing values generated
      kproad: 1940 missing values generated
      aproad: 1944 missing values generated
     bustrly: 1940 missing values generated
     numhins: 1939 missing values generated
 arrived_fdi: 1940 missing values generated
     tot_emp: 1936 missing values generated
tot_emp_se~2: 1937 missing values generated
tot_emp_se~3: 1937 missing values generated
        giov: 1937 missing values generated
 giov_soecol: 1942 missing values generated
    tot_area: 1935 missing values generated
    giov_new: 1958 missing values generated
giov_soeco~w: 1958 missing values generated
         pop: 883 missing values generated
gdp_michigan: 882 missing values generated
gdp_sec~2_mi: 889 missing values generated
gdp_sec~3_mi: 889 missing values generated
        givo: 886 missing values generated
givo_domes~c: 901 missing values generated
givo_hk_mc~w: 963 missing values generated
givo_foreign: 950 missing values generated
sal_staffw~k: 897 missing values generated
 college_stu: 953 missing values generated
  area_pvdrd: 1909 missing values generated
pvdrd_percap: 1909 missing values generated
    bus_trol: 1647 missing values generated
 s02_tonyrkm: 1147 missing values generated
unit_code_08: 885 missing values generated
   cultiland: 1507 missing values generated
      totemp: 1630 missing values generated
      agremp: 1959 missing values generated
      minemp: 1959 missing values generated
     manuemp: 1959 missing values generated
      egwemp: 1959 missing values generated
    constemp: 1959 missing values generated
     geolemp: 1959 missing values generated
      tstemp: 1959 missing values generated
    whoreemp: 1959 missing values generated
   fininsemp: 1959 missing values generated
       reemp: 1959 missing values generated
       ssemp: 1959 missing values generated
       hsemp: 1959 missing values generated
      ecmemp: 1959 missing values generated
       stemp: 1959 missing values generated
      pubemp: 1959 missing values generated
      gdp_py: 1631 missing values generated
   gdp_sect2: 1631 missing values generated
   gdp_sect3: 1631 missing values generated
   total_pop: 1630 missing values generated
        kmpr: 1959 missing values generated
         apr: 1959 missing values generated
        prpc: 1959 missing values generated
      num_bt: 1959 missing values generated
   avgsalary: 1774 missing values generated
  num_colstd: 1674 missing values generated
    givo_soe: 1815 missing values generated
   givo_colt: 1815 missing values generated
     exp_lgt: 1816 missing values generated
    num_hedu: 1841 missing values generated
   publibcol: 1815 missing values generated
     culland: 1800 missing values generated
        area: 1815 missing values generated
   emp_sect2: 1630 missing values generated
   emp_sect3: 1630 missing values generated
   fixinvest: 1630 missing values generated
         fdi: 1664 missing values generated
  tot_fixinv: 901 missing values generated
          a5: 1708 missing values generated
          a6: 1708 missing values generated
        a101: 1671 missing values generated
        a102: 1671 missing values generated
        a103: 1671 missing values generated
        a104: 1671 missing values generated
        a105: 1671 missing values generated
        a106: 1671 missing values generated
        a107: 1671 missing values generated
        a108: 1671 missing values generated
        a109: 1671 missing values generated
        a110: 1671 missing values generated
        a111: 1671 missing values generated
        a112: 1671 missing values generated
        a113: 1768 missing values generated
        a114: 1768 missing values generated
        a115: 1768 missing values generated
        a116: 1769 missing values generated
        a117: 1671 missing values generated
        a118: 1671 missing values generated
        a119: 1671 missing values generated
        a120: 1671 missing values generated
        a121: 1671 missing values generated
        a122: 1671 missing values generated
        a123: 1671 missing values generated
        a124: 1671 missing values generated
        a125: 1671 missing values generated
        a126: 1674 missing values generated
        a127: 1674 missing values generated
        a128: 1674 missing values generated
        a129: 1674 missing values generated
        a130: 1674 missing values generated
        a131: 1674 missing values generated
        a132: 1674 missing values generated
        a133: 1674 missing values generated
        a134: 1674 missing values generated
        a135: 1674 missing values generated
        a136: 1674 missing values generated
        a137: 1674 missing values generated
        a138: 1674 missing values generated
        a139: 1674 missing values generated
        a140: 1674 missing values generated
        a141: 1674 missing values generated
        a142: 1674 missing values generated
        a143: 1674 missing values generated
        a144: 1674 missing values generated
        a145: 1674 missing values generated
        a146: 1674 missing values generated
        a181: 1671 missing values generated
        a182: 1671 missing values generated
        a183: 1671 missing values generated
        a184: 1671 missing values generated
        a185: 1671 missing values generated
        a186: 1671 missing values generated
        a187: 1671 missing values generated
        a188: 1671 missing values generated
        a189: 1671 missing values generated
        a190: 1671 missing values generated
        a191: 1671 missing values generated
        a192: 1671 missing values generated
        a193: 1671 missing values generated
        a194: 1671 missing values generated
        a195: 1671 missing values generated
        a196: 1671 missing values generated
        a197: 1671 missing values generated
        a198: 1671 missing values generated
        a199: 1671 missing values generated
        a200: 1671 missing values generated
        a201: 1671 missing values generated
        a202: 1671 missing values generated
        a203: 1671 missing values generated
        a204: 1671 missing values generated
        a205: 1671 missing values generated
        a206: 1671 missing values generated
        a207: 1671 missing values generated
        a208: 1671 missing values generated
        a209: 1671 missing values generated
        a210: 1671 missing values generated
        a211: 1671 missing values generated
        a212: 1671 missing values generated
        a213: 1671 missing values generated
        a214: 1671 missing values generated
        a215: 1671 missing values generated
        a216: 1671 missing values generated
        a217: 1671 missing values generated
        a218: 1671 missing values generated
        a219: 1671 missing values generated
        a220: 1671 missing values generated
        a221: 1671 missing values generated
        a222: 1671 missing values generated
        a223: 1671 missing values generated
        a224: 1671 missing values generated
        a225: 1671 missing values generated
        a226: 1671 missing values generated
        a227: 1671 missing values generated
        a228: 1671 missing values generated
        a229: 1671 missing values generated
        a230: 1671 missing values generated
        a231: 1671 missing values generated
        a232: 1671 missing values generated
        a233: 1671 missing values generated
        a234: 1671 missing values generated
        a235: 1671 missing values generated
        a236: 1671 missing values generated
        a237: 1671 missing values generated
        a238: 1671 missing values generated
        a239: 1671 missing values generated
        a240: 1671 missing values generated
        a241: 1687 missing values generated
        a242: 1690 missing values generated
        a243: 1687 missing values generated
        a244: 1699 missing values generated
        a245: 1751 missing values generated
        a246: 1709 missing values generated
        a261: 1671 missing values generated
        a262: 1671 missing values generated
        a263: 1671 missing values generated
        a264: 1671 missing values generated
        a265: 1671 missing values generated
        a266: 1671 missing values generated
        a267: 1671 missing values generated
        a268: 1671 missing values generated
        a269: 1671 missing values generated
        a270: 1671 missing values generated
        a271: 1671 missing values generated
        a272: 1671 missing values generated
        a273: 1671 missing values generated
        a274: 1671 missing values generated
        a275: 1671 missing values generated
        a276: 1671 missing values generated
        a277: 1671 missing values generated
        a278: 1671 missing values generated
        a279: 1671 missing values generated
        a280: 1671 missing values generated
        a281: 1671 missing values generated
        a282: 1671 missing values generated
        a283: 1671 missing values generated
        a284: 1671 missing values generated
        a291: 1671 missing values generated
        a292: 1671 missing values generated
        a293: 1671 missing values generated
        a294: 1671 missing values generated
        a295: 1671 missing values generated
        a296: 1671 missing values generated
        a301: 1671 missing values generated
        a302: 1671 missing values generated
        a303: 1671 missing values generated
        a304: 1671 missing values generated
        a305: 1671 missing values generated
        a306: 1671 missing values generated
        a307: 1671 missing values generated
        a308: 1671 missing values generated
        a309: 1671 missing values generated
        a310: 1671 missing values generated
        a311: 1671 missing values generated
        a312: 1671 missing values generated
        a313: 1671 missing values generated
        a314: 1671 missing values generated
        a315: 1671 missing values generated
        a321: 1671 missing values generated
        a322: 1671 missing values generated
        a323: 1671 missing values generated
        a324: 1671 missing values generated
        a325: 1671 missing values generated
        a326: 1671 missing values generated
        a327: 1671 missing values generated
        a328: 1671 missing values generated
        a329: 1671 missing values generated
        a330: 1671 missing values generated
        a331: 1671 missing values generated
        a332: 1671 missing values generated
        a341: 1671 missing values generated
        a342: 1671 missing values generated
        a343: 1671 missing values generated
        a344: 1671 missing values generated
        a345: 1671 missing values generated
        a346: 1671 missing values generated
        a347: 1671 missing values generated
        a348: 1671 missing values generated
        a349: 1671 missing values generated
        a350: 1671 missing values generated
        a351: 1671 missing values generated
        a352: 1671 missing values generated
        a361: 1671 missing values generated
        a362: 1671 missing values generated
        a363: 1671 missing values generated
        a364: 1671 missing values generated
        a365: 1671 missing values generated
        a366: 1671 missing values generated
        a367: 1671 missing values generated
        a368: 1671 missing values generated
        a369: 1671 missing values generated
        a370: 1683 missing values generated
        a381: 1671 missing values generated
        a382: 1671 missing values generated
        a383: 1671 missing values generated
        a384: 1671 missing values generated
        a385: 1671 missing values generated
        a386: 1671 missing values generated
        a387: 1671 missing values generated
        a388: 1671 missing values generated
        a389: 1671 missing values generated
        a390: 1673 missing values generated
        a391: 1673 missing values generated
        a392: 1678 missing values generated
        a393: 1671 missing values generated
        a394: 1671 missing values generated
        a395: 1671 missing values generated
        a396: 1671 missing values generated
        a397: 1671 missing values generated
        a398: 1671 missing values generated
        a399: 1671 missing values generated
        a400: 1671 missing values generated
        a401: 1671 missing values generated
        a402: 1671 missing values generated
        a403: 1671 missing values generated
        a404: 1671 missing values generated
        a405: 1674 missing values generated
        a406: 1674 missing values generated
        a407: 1674 missing values generated
        a408: 1671 missing values generated
        a409: 1671 missing values generated
        a410: 1671 missing values generated
        a411: 1672 missing values generated
        a412: 1672 missing values generated
        a413: 1672 missing values generated
        a414: 1671 missing values generated
        a415: 1671 missing values generated
        a416: 1672 missing values generated
        a417: 1671 missing values generated
        a418: 1671 missing values generated
        a419: 1671 missing values generated
        a420: 1686 missing values generated
        a421: 1687 missing values generated
        a422: 1705 missing values generated
        a423: 1671 missing values generated
        a424: 1671 missing values generated
        a425: 1671 missing values generated
        a426: 1671 missing values generated
        a427: 1671 missing values generated
        a428: 1671 missing values generated
        a431: 1671 missing values generated
        a432: 1671 missing values generated
        a433: 1671 missing values generated
        a434: 1671 missing values generated
        a435: 1671 missing values generated
        a436: 1671 missing values generated
        a437: 1671 missing values generated
        a438: 1671 missing values generated
        a439: 1671 missing values generated
        a440: 1671 missing values generated
        a441: 1671 missing values generated
        a442: 1671 missing values generated
        a443: 1671 missing values generated
        a444: 1671 missing values generated
        a445: 1671 missing values generated
        a446: 1671 missing values generated
        a447: 1671 missing values generated
        a448: 1671 missing values generated
        a449: 1671 missing values generated
        a450: 1671 missing values generated
        a451: 1671 missing values generated
        a452: 1688 missing values generated
        a453: 1692 missing values generated
        a454: 1697 missing values generated
        a701: 1671 missing values generated
        a702: 1671 missing values generated
        a703: 1671 missing values generated
        a704: 1672 missing values generated
        a705: 1673 missing values generated
        a706: 1672 missing values generated
        a707: 1671 missing values generated
        a708: 1671 missing values generated
        a709: 1671 missing values generated
        a710: 1675 missing values generated
        a711: 1687 missing values generated
        a712: 1679 missing values generated
        a713: 1710 missing values generated
        a714: 1753 missing values generated
        a715: 1730 missing values generated
        a716: 1672 missing values generated
        a717: 1676 missing values generated
        a718: 1672 missing values generated
        a719: 1673 missing values generated
        a720: 1686 missing values generated
        a721: 1676 missing values generated
        a722: 1671 missing values generated
        a723: 1671 missing values generated
        a724: 1671 missing values generated
        a725: 1684 missing values generated
        a726: 1703 missing values generated
        a727: 1692 missing values generated
        a728: 1680 missing values generated
        a729: 1693 missing values generated
        a730: 1684 missing values generated
        a731: 1671 missing values generated
        a732: 1671 missing values generated
        a733: 1672 missing values generated
        a734: 1679 missing values generated
        a735: 1693 missing values generated
        a736: 1683 missing values generated
        a737: 1694 missing values generated
        a738: 1716 missing values generated
        a739: 1701 missing values generated
        a740: 1686 missing values generated
        a741: 1706 missing values generated
        a742: 1694 missing values generated
        a743: 1672 missing values generated
        a744: 1676 missing values generated
        a745: 1672 missing values generated
        a746: 1775 missing values generated
        a747: 1838 missing values generated
        a748: 1789 missing values generated
        a749: 1871 missing values generated
        a750: 1907 missing values generated
        a751: 1890 missing values generated
        a752: 1733 missing values generated
        a753: 1808 missing values generated
        a754: 1738 missing values generated
        a755: 1728 missing values generated
        a756: 1769 missing values generated
        a757: 1740 missing values generated
        a758: 1775 missing values generated
        a759: 1835 missing values generated
        a760: 1790 missing values generated
        a761: 1820 missing values generated
        a762: 1877 missing values generated
        a763: 1831 missing values generated
        a764: 1713 missing values generated
        a765: 1735 missing values generated
        a766: 1741 missing values generated
        a767: 1759 missing values generated
        a768: 1793 missing values generated
        a769: 1772 missing values generated
        a770: 1819 missing values generated
        a771: 1884 missing values generated
        a772: 1831 missing values generated
        a773: 1745 missing values generated
        a774: 1790 missing values generated
        a775: 1764 missing values generated
        a776: 1875 missing values generated
        a777: 1900 missing values generated
        a778: 1892 missing values generated
        a779: 1767 missing values generated
        a780: 1819 missing values generated
        a781: 1783 missing values generated
        a782: 1878 missing values generated
        a783: 1926 missing values generated
        a784: 1884 missing values generated
        a785: 1917 missing values generated
        a786: 1927 missing values generated
        a787: 1927 missing values generated
        a788: 1738 missing values generated
        a789: 1786 missing values generated
        a790: 1757 missing values generated
        a791: 1805 missing values generated
        a792: 1835 missing values generated
        a793: 1817 missing values generated
        a794: 1786 missing values generated
        a795: 1835 missing values generated
        a796: 1805 missing values generated
        a797: 1796 missing values generated
        a798: 1852 missing values generated
        a799: 1818 missing values generated
        a800: 1876 missing values generated
        a801: 1928 missing values generated
        a802: 1881 missing values generated
        a803: 1879 missing values generated
        a804: 1918 missing values generated
        a805: 1890 missing values generated
        a806: 1846 missing values generated
        a807: 1889 missing values generated
        a808: 1858 missing values generated
        a809: 1799 missing values generated
        a810: 1828 missing values generated
        a811: 1827 missing values generated
        a812: 1739 missing values generated
        a813: 1773 missing values generated
        a814: 1748 missing values generated
        a815: 1914 missing values generated
        a816: 1937 missing values generated
        a817: 1923 missing values generated
        a818: 1871 missing values generated
        a819: 1908 missing values generated
        a820: 1887 missing values generated
        a821: 1946 missing values generated
        a822: 1950 missing values generated
        a823: 1953 missing values generated
        a824: 1911 missing values generated
        a825: 1943 missing values generated
        a826: 1914 missing values generated
        a827: 1943 missing values generated
        a828: 1950 missing values generated
        a829: 1948 missing values generated
        a830: 1847 missing values generated
        a831: 1882 missing values generated
        a832: 1856 missing values generated
        a833: 1887 missing values generated
        a834: 1907 missing values generated
        a835: 1898 missing values generated
        a836: 1935 missing values generated
        a837: 1948 missing values generated
        a838: 1939 missing values generated
        a839: 1936 missing values generated
        a840: 1946 missing values generated
        a841: 1939 missing values generated
        a842: 1921 missing values generated
        a843: 1938 missing values generated
        a844: 1924 missing values generated
        a845: 1831 missing values generated
        a846: 1876 missing values generated
        a847: 1848 missing values generated
        a848: 1926 missing values generated
        a849: 1939 missing values generated
        a850: 1938 missing values generated
        a851: 1906 missing values generated
        a852: 1938 missing values generated
        a853: 1909 missing values generated
        a854: 1888 missing values generated
        a855: 1914 missing values generated
        a856: 1897 missing values generated
        a857: 1897 missing values generated
        a858: 1919 missing values generated
        a859: 1901 missing values generated
        a860: 1933 missing values generated
        a861: 1947 missing values generated
        a862: 1935 missing values generated
        a863: 1930 missing values generated
        a864: 1948 missing values generated
        a865: 1933 missing values generated
        a866: 1929 missing values generated
        a867: 1944 missing values generated
        a868: 1931 missing values generated
        a869: 1773 missing values generated
        a870: 1805 missing values generated
        a871: 1789 missing values generated
        a872: 1783 missing values generated
        a873: 1874 missing values generated
        a874: 1789 missing values generated
  asset_g_qz: 1802 missing values generated
  asset_n_qz: 1015 missing values generated

. gen new = 0

. append using temp_us123.dta

. replace new = 1 if new==.
(451 real changes made)

. /*** Set all obs of variables to . if do not populate 
>                         all obs within groups. *****/
. sort city05 year

. by city05 year: gen obs = _N

. foreach X of varlist gdp-a874 asset_g_qz asset_n_qz {
  2.    egen varcount = count(`X'), by(city05 year)
  3.    replace `X' = . if varcount<obs
  4.    drop varcount
  5. }
(5 real changes made, 5 to missing)
(0 real changes made)
(6 real changes made, 6 to missing)
(0 real changes made)
(5 real changes made, 5 to missing)
(0 real changes made)
(5 real changes made, 5 to missing)
(0 real changes made)
(6 real changes made, 6 to missing)
(6 real changes made, 6 to missing)
(0 real changes made)
(8 real changes made, 8 to missing)
(0 real changes made)
(8 real changes made, 8 to missing)
(0 real changes made)
(6 real changes made, 6 to missing)
(3 real changes made, 3 to missing)
(5 real changes made, 5 to missing)
(3 real changes made, 3 to missing)
(4 real changes made, 4 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(0 real changes made)
(0 real changes made)
(3 real changes made, 3 to missing)
(0 real changes made)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(2 real changes made, 2 to missing)
(2 real changes made, 2 to missing)
(2 real changes made, 2 to missing)
(2 real changes made, 2 to missing)
(3 real changes made, 3 to missing)
(2 real changes made, 2 to missing)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(3 real changes made, 3 to missing)
(0 real changes made)
(25 real changes made, 25 to missing)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(25 real changes made, 25 to missing)
(25 real changes made, 25 to missing)
(25 real changes made, 25 to missing)
(25 real changes made, 25 to missing)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(2 real changes made, 2 to missing)
(24 real changes made, 24 to missing)
(23 real changes made, 23 to missing)
(23 real changes made, 23 to missing)
(23 real changes made, 23 to missing)
(20 real changes made, 20 to missing)
(23 real changes made, 23 to missing)
(38 real changes made, 38 to missing)
(23 real changes made, 23 to missing)
(25 real changes made, 25 to missing)
(25 real changes made, 25 to missing)
(25 real changes made, 25 to missing)
(22 real changes made, 22 to missing)
(3 real changes made, 3 to missing)
(25 real changes made, 25 to missing)
(25 real changes made, 25 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(22 real changes made, 22 to missing)
(22 real changes made, 22 to missing)
(22 real changes made, 22 to missing)
(22 real changes made, 22 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(7 real changes made, 7 to missing)
(7 real changes made, 7 to missing)
(7 real changes made, 7 to missing)
(11 real changes made, 11 to missing)
(19 real changes made, 19 to missing)
(18 real changes made, 18 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(10 real changes made, 10 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(6 real changes made, 6 to missing)
(6 real changes made, 6 to missing)
(10 real changes made, 10 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(3 real changes made, 3 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(4 real changes made, 4 to missing)
(4 real changes made, 4 to missing)
(4 real changes made, 4 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(2 real changes made, 2 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(8 real changes made, 8 to missing)
(8 real changes made, 8 to missing)
(14 real changes made, 14 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(8 real changes made, 8 to missing)
(9 real changes made, 9 to missing)
(11 real changes made, 11 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(4 real changes made, 4 to missing)
(4 real changes made, 4 to missing)
(4 real changes made, 4 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(4 real changes made, 4 to missing)
(7 real changes made, 7 to missing)
(5 real changes made, 5 to missing)
(16 real changes made, 16 to missing)
(22 real changes made, 22 to missing)
(23 real changes made, 23 to missing)
(1 real change made, 1 to missing)
(7 real changes made, 7 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(10 real changes made, 10 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(10 real changes made, 10 to missing)
(13 real changes made, 13 to missing)
(10 real changes made, 10 to missing)
(4 real changes made, 4 to missing)
(10 real changes made, 10 to missing)
(4 real changes made, 4 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(4 real changes made, 4 to missing)
(5 real changes made, 5 to missing)
(14 real changes made, 14 to missing)
(5 real changes made, 5 to missing)
(10 real changes made, 10 to missing)
(15 real changes made, 15 to missing)
(12 real changes made, 12 to missing)
(8 real changes made, 8 to missing)
(12 real changes made, 12 to missing)
(13 real changes made, 13 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(1 real change made, 1 to missing)
(27 real changes made, 27 to missing)
(39 real changes made, 39 to missing)
(32 real changes made, 32 to missing)
(50 real changes made, 50 to missing)
(49 real changes made, 49 to missing)
(53 real changes made, 53 to missing)
(26 real changes made, 26 to missing)
(30 real changes made, 30 to missing)
(27 real changes made, 27 to missing)
(16 real changes made, 16 to missing)
(21 real changes made, 21 to missing)
(16 real changes made, 16 to missing)
(30 real changes made, 30 to missing)
(36 real changes made, 36 to missing)
(31 real changes made, 31 to missing)
(42 real changes made, 42 to missing)
(43 real changes made, 43 to missing)
(48 real changes made, 48 to missing)
(13 real changes made, 13 to missing)
(16 real changes made, 16 to missing)
(20 real changes made, 20 to missing)
(30 real changes made, 30 to missing)
(33 real changes made, 33 to missing)
(30 real changes made, 30 to missing)
(35 real changes made, 35 to missing)
(42 real changes made, 42 to missing)
(35 real changes made, 35 to missing)
(18 real changes made, 18 to missing)
(27 real changes made, 27 to missing)
(24 real changes made, 24 to missing)
(43 real changes made, 43 to missing)
(46 real changes made, 46 to missing)
(43 real changes made, 43 to missing)
(26 real changes made, 26 to missing)
(33 real changes made, 33 to missing)
(29 real changes made, 29 to missing)
(38 real changes made, 38 to missing)
(40 real changes made, 40 to missing)
(38 real changes made, 38 to missing)
(41 real changes made, 41 to missing)
(42 real changes made, 42 to missing)
(41 real changes made, 41 to missing)
(31 real changes made, 31 to missing)
(37 real changes made, 37 to missing)
(29 real changes made, 29 to missing)
(24 real changes made, 24 to missing)
(32 real changes made, 32 to missing)
(25 real changes made, 25 to missing)
(30 real changes made, 30 to missing)
(35 real changes made, 35 to missing)
(32 real changes made, 32 to missing)
(40 real changes made, 40 to missing)
(45 real changes made, 45 to missing)
(43 real changes made, 43 to missing)
(53 real changes made, 53 to missing)
(49 real changes made, 49 to missing)
(52 real changes made, 52 to missing)
(48 real changes made, 48 to missing)
(46 real changes made, 46 to missing)
(48 real changes made, 48 to missing)
(28 real changes made, 28 to missing)
(27 real changes made, 27 to missing)
(33 real changes made, 33 to missing)
(34 real changes made, 34 to missing)
(33 real changes made, 33 to missing)
(36 real changes made, 36 to missing)
(18 real changes made, 18 to missing)
(20 real changes made, 20 to missing)
(18 real changes made, 18 to missing)
(47 real changes made, 47 to missing)
(46 real changes made, 46 to missing)
(47 real changes made, 47 to missing)
(41 real changes made, 41 to missing)
(44 real changes made, 44 to missing)
(42 real changes made, 42 to missing)
(48 real changes made, 48 to missing)
(47 real changes made, 47 to missing)
(50 real changes made, 50 to missing)
(48 real changes made, 48 to missing)
(43 real changes made, 43 to missing)
(49 real changes made, 49 to missing)
(50 real changes made, 50 to missing)
(48 real changes made, 48 to missing)
(49 real changes made, 49 to missing)
(32 real changes made, 32 to missing)
(37 real changes made, 37 to missing)
(37 real changes made, 37 to missing)
(43 real changes made, 43 to missing)
(42 real changes made, 42 to missing)
(42 real changes made, 42 to missing)
(49 real changes made, 49 to missing)
(48 real changes made, 48 to missing)
(49 real changes made, 49 to missing)
(43 real changes made, 43 to missing)
(43 real changes made, 43 to missing)
(43 real changes made, 43 to missing)
(44 real changes made, 44 to missing)
(43 real changes made, 43 to missing)
(44 real changes made, 44 to missing)
(34 real changes made, 34 to missing)
(31 real changes made, 31 to missing)
(37 real changes made, 37 to missing)
(51 real changes made, 51 to missing)
(50 real changes made, 50 to missing)
(49 real changes made, 49 to missing)
(47 real changes made, 47 to missing)
(50 real changes made, 50 to missing)
(47 real changes made, 47 to missing)
(35 real changes made, 35 to missing)
(37 real changes made, 37 to missing)
(39 real changes made, 39 to missing)
(41 real changes made, 41 to missing)
(43 real changes made, 43 to missing)
(39 real changes made, 39 to missing)
(50 real changes made, 50 to missing)
(48 real changes made, 48 to missing)
(49 real changes made, 49 to missing)
(41 real changes made, 41 to missing)
(46 real changes made, 46 to missing)
(41 real changes made, 41 to missing)
(46 real changes made, 46 to missing)
(49 real changes made, 49 to missing)
(46 real changes made, 46 to missing)
(29 real changes made, 29 to missing)
(40 real changes made, 40 to missing)
(30 real changes made, 30 to missing)
(15 real changes made, 15 to missing)
(29 real changes made, 29 to missing)
(18 real changes made, 18 to missing)
(31 real changes made, 31 to missing)
(34 real changes made, 34 to missing)

. *** These are fully imputed prefectures
. egen minnew = min(new), by(city05 year)

. replace gdp_py = . if minnew==1
(0 real changes made)

. replace gdp_sect2 = . if minnew==1
(0 real changes made)

. 
. collapse (sum) gdp-a874 asset_g_qz asset_n_qz obs, by(city05 year)

. 
. /*** All . aggregate to 0 so recode to . NOTE there are only a few genuine 0 obs
> in the data, but none for population or gdp ***/
. mvdecode gdp-a874 asset_g_qz asset_n_qz, mv(0)
         gdp: 1705 missing values generated
         nnp: 1999 missing values generated
 gdp_sector1: 1764 missing values generated
 nnp_sector1: 1990 missing values generated
 gdp_sector2: 1721 missing values generated
 nnp_sector2: 1982 missing values generated
 gdp_sector3: 1721 missing values generated
 nnp_sector3: 1982 missing values generated
     tot_pop: 1704 missing values generated
     r08_gdp: 1824 missing values generated
     r08_nnp: 2001 missing values generated
r08_gdp_se~2: 1831 missing values generated
r08_nnp_se~2: 1997 missing values generated
r08_gdp_se~3: 1831 missing values generated
r08_nnp_se~3: 1997 missing values generated
 r08_tot_pop: 1839 missing values generated
     num_car: 1812 missing values generated
    dust_ems: 1808 missing values generated
     gas_ems: 1781 missing values generated
         so2: 1796 missing values generated
      kproad: 1984 missing values generated
      aproad: 1988 missing values generated
     bustrly: 1984 missing values generated
     numhins: 1983 missing values generated
 arrived_fdi: 1984 missing values generated
     tot_emp: 1980 missing values generated
tot_emp_se~2: 1981 missing values generated
tot_emp_se~3: 1981 missing values generated
        giov: 1981 missing values generated
 giov_soecol: 1986 missing values generated
    tot_area: 1979 missing values generated
    giov_new: 2001 missing values generated
giov_soeco~w: 2001 missing values generated
         pop: 926 missing values generated
gdp_michigan: 924 missing values generated
gdp_sec~2_mi: 935 missing values generated
gdp_sec~3_mi: 935 missing values generated
        givo: 931 missing values generated
givo_domes~c: 946 missing values generated
givo_hk_mc~w: 1008 missing values generated
givo_foreign: 995 missing values generated
sal_staffw~k: 943 missing values generated
 college_stu: 998 missing values generated
  area_pvdrd: 1952 missing values generated
pvdrd_percap: 1952 missing values generated
    bus_trol: 1690 missing values generated
 s02_tonyrkm: 1190 missing values generated
unit_code_08: 931 missing values generated
   cultiland: 1550 missing values generated
      totemp: 1698 missing values generated
      agremp: 2002 missing values generated
      minemp: 2002 missing values generated
     manuemp: 2002 missing values generated
      egwemp: 2002 missing values generated
    constemp: 2002 missing values generated
     geolemp: 2002 missing values generated
      tstemp: 2002 missing values generated
    whoreemp: 2002 missing values generated
   fininsemp: 2002 missing values generated
       reemp: 2002 missing values generated
       ssemp: 2002 missing values generated
       hsemp: 2002 missing values generated
      ecmemp: 2002 missing values generated
       stemp: 2002 missing values generated
      pubemp: 2002 missing values generated
      gdp_py: 1699 missing values generated
   gdp_sect2: 1699 missing values generated
   gdp_sect3: 1699 missing values generated
   total_pop: 1698 missing values generated
        kmpr: 2002 missing values generated
         apr: 2002 missing values generated
        prpc: 2002 missing values generated
      num_bt: 2002 missing values generated
   avgsalary: 1819 missing values generated
  num_colstd: 1741 missing values generated
    givo_soe: 1881 missing values generated
   givo_colt: 1881 missing values generated
     exp_lgt: 1882 missing values generated
    num_hedu: 1904 missing values generated
   publibcol: 1881 missing values generated
     culland: 1841 missing values generated
        area: 1881 missing values generated
   emp_sect2: 1698 missing values generated
   emp_sect3: 1698 missing values generated
   fixinvest: 1698 missing values generated
         fdi: 1728 missing values generated
  tot_fixinv: 947 missing values generated
          a5: 1789 missing values generated
          a6: 1789 missing values generated
        a101: 1716 missing values generated
        a102: 1716 missing values generated
        a103: 1716 missing values generated
        a104: 1716 missing values generated
        a105: 1716 missing values generated
        a106: 1716 missing values generated
        a107: 1716 missing values generated
        a108: 1716 missing values generated
        a109: 1716 missing values generated
        a110: 1716 missing values generated
        a111: 1716 missing values generated
        a112: 1716 missing values generated
        a113: 1816 missing values generated
        a114: 1816 missing values generated
        a115: 1816 missing values generated
        a116: 1817 missing values generated
        a117: 1716 missing values generated
        a118: 1716 missing values generated
        a119: 1716 missing values generated
        a120: 1716 missing values generated
        a121: 1716 missing values generated
        a122: 1716 missing values generated
        a123: 1716 missing values generated
        a124: 1716 missing values generated
        a125: 1716 missing values generated
        a126: 1719 missing values generated
        a127: 1719 missing values generated
        a128: 1719 missing values generated
        a129: 1719 missing values generated
        a130: 1719 missing values generated
        a131: 1719 missing values generated
        a132: 1719 missing values generated
        a133: 1719 missing values generated
        a134: 1719 missing values generated
        a135: 1719 missing values generated
        a136: 1719 missing values generated
        a137: 1719 missing values generated
        a138: 1719 missing values generated
        a139: 1719 missing values generated
        a140: 1719 missing values generated
        a141: 1719 missing values generated
        a142: 1719 missing values generated
        a143: 1719 missing values generated
        a144: 1719 missing values generated
        a145: 1719 missing values generated
        a146: 1719 missing values generated
        a181: 1716 missing values generated
        a182: 1716 missing values generated
        a183: 1716 missing values generated
        a184: 1716 missing values generated
        a185: 1716 missing values generated
        a186: 1716 missing values generated
        a187: 1716 missing values generated
        a188: 1716 missing values generated
        a189: 1716 missing values generated
        a190: 1716 missing values generated
        a191: 1716 missing values generated
        a192: 1716 missing values generated
        a193: 1716 missing values generated
        a194: 1716 missing values generated
        a195: 1716 missing values generated
        a196: 1716 missing values generated
        a197: 1716 missing values generated
        a198: 1716 missing values generated
        a199: 1716 missing values generated
        a200: 1716 missing values generated
        a201: 1716 missing values generated
        a202: 1716 missing values generated
        a203: 1716 missing values generated
        a204: 1716 missing values generated
        a205: 1716 missing values generated
        a206: 1716 missing values generated
        a207: 1716 missing values generated
        a208: 1716 missing values generated
        a209: 1716 missing values generated
        a210: 1716 missing values generated
        a211: 1716 missing values generated
        a212: 1716 missing values generated
        a213: 1716 missing values generated
        a214: 1716 missing values generated
        a215: 1716 missing values generated
        a216: 1716 missing values generated
        a217: 1716 missing values generated
        a218: 1716 missing values generated
        a219: 1716 missing values generated
        a220: 1716 missing values generated
        a221: 1716 missing values generated
        a222: 1716 missing values generated
        a223: 1716 missing values generated
        a224: 1716 missing values generated
        a225: 1716 missing values generated
        a226: 1716 missing values generated
        a227: 1716 missing values generated
        a228: 1716 missing values generated
        a229: 1716 missing values generated
        a230: 1716 missing values generated
        a231: 1716 missing values generated
        a232: 1716 missing values generated
        a233: 1716 missing values generated
        a234: 1716 missing values generated
        a235: 1716 missing values generated
        a236: 1716 missing values generated
        a237: 1716 missing values generated
        a238: 1716 missing values generated
        a239: 1716 missing values generated
        a240: 1716 missing values generated
        a241: 1730 missing values generated
        a242: 1733 missing values generated
        a243: 1730 missing values generated
        a244: 1743 missing values generated
        a245: 1792 missing values generated
        a246: 1753 missing values generated
        a261: 1716 missing values generated
        a262: 1716 missing values generated
        a263: 1716 missing values generated
        a264: 1716 missing values generated
        a265: 1716 missing values generated
        a266: 1716 missing values generated
        a267: 1716 missing values generated
        a268: 1716 missing values generated
        a269: 1716 missing values generated
        a270: 1716 missing values generated
        a271: 1716 missing values generated
        a272: 1716 missing values generated
        a273: 1716 missing values generated
        a274: 1716 missing values generated
        a275: 1716 missing values generated
        a276: 1716 missing values generated
        a277: 1716 missing values generated
        a278: 1716 missing values generated
        a279: 1716 missing values generated
        a280: 1716 missing values generated
        a281: 1716 missing values generated
        a282: 1716 missing values generated
        a283: 1716 missing values generated
        a284: 1716 missing values generated
        a291: 1716 missing values generated
        a292: 1716 missing values generated
        a293: 1716 missing values generated
        a294: 1716 missing values generated
        a295: 1716 missing values generated
        a296: 1716 missing values generated
        a301: 1716 missing values generated
        a302: 1716 missing values generated
        a303: 1716 missing values generated
        a304: 1716 missing values generated
        a305: 1716 missing values generated
        a306: 1716 missing values generated
        a307: 1716 missing values generated
        a308: 1716 missing values generated
        a309: 1716 missing values generated
        a310: 1716 missing values generated
        a311: 1716 missing values generated
        a312: 1716 missing values generated
        a313: 1716 missing values generated
        a314: 1716 missing values generated
        a315: 1716 missing values generated
        a321: 1716 missing values generated
        a322: 1716 missing values generated
        a323: 1716 missing values generated
        a324: 1716 missing values generated
        a325: 1716 missing values generated
        a326: 1716 missing values generated
        a327: 1716 missing values generated
        a328: 1716 missing values generated
        a329: 1716 missing values generated
        a330: 1716 missing values generated
        a331: 1716 missing values generated
        a332: 1716 missing values generated
        a341: 1716 missing values generated
        a342: 1716 missing values generated
        a343: 1716 missing values generated
        a344: 1716 missing values generated
        a345: 1716 missing values generated
        a346: 1716 missing values generated
        a347: 1716 missing values generated
        a348: 1716 missing values generated
        a349: 1716 missing values generated
        a350: 1716 missing values generated
        a351: 1716 missing values generated
        a352: 1716 missing values generated
        a361: 1716 missing values generated
        a362: 1716 missing values generated
        a363: 1716 missing values generated
        a364: 1716 missing values generated
        a365: 1716 missing values generated
        a366: 1716 missing values generated
        a367: 1716 missing values generated
        a368: 1716 missing values generated
        a369: 1716 missing values generated
        a370: 1728 missing values generated
        a381: 1716 missing values generated
        a382: 1716 missing values generated
        a383: 1716 missing values generated
        a384: 1716 missing values generated
        a385: 1716 missing values generated
        a386: 1716 missing values generated
        a387: 1716 missing values generated
        a388: 1716 missing values generated
        a389: 1716 missing values generated
        a390: 1718 missing values generated
        a391: 1718 missing values generated
        a392: 1724 missing values generated
        a393: 1716 missing values generated
        a394: 1716 missing values generated
        a395: 1716 missing values generated
        a396: 1716 missing values generated
        a397: 1716 missing values generated
        a398: 1716 missing values generated
        a399: 1716 missing values generated
        a400: 1716 missing values generated
        a401: 1716 missing values generated
        a402: 1716 missing values generated
        a403: 1716 missing values generated
        a404: 1716 missing values generated
        a405: 1719 missing values generated
        a406: 1719 missing values generated
        a407: 1719 missing values generated
        a408: 1716 missing values generated
        a409: 1716 missing values generated
        a410: 1716 missing values generated
        a411: 1717 missing values generated
        a412: 1717 missing values generated
        a413: 1717 missing values generated
        a414: 1716 missing values generated
        a415: 1716 missing values generated
        a416: 1717 missing values generated
        a417: 1716 missing values generated
        a418: 1716 missing values generated
        a419: 1716 missing values generated
        a420: 1731 missing values generated
        a421: 1732 missing values generated
        a422: 1753 missing values generated
        a423: 1716 missing values generated
        a424: 1716 missing values generated
        a425: 1716 missing values generated
        a426: 1716 missing values generated
        a427: 1716 missing values generated
        a428: 1716 missing values generated
        a431: 1716 missing values generated
        a432: 1716 missing values generated
        a433: 1716 missing values generated
        a434: 1716 missing values generated
        a435: 1716 missing values generated
        a436: 1716 missing values generated
        a437: 1716 missing values generated
        a438: 1716 missing values generated
        a439: 1716 missing values generated
        a440: 1716 missing values generated
        a441: 1716 missing values generated
        a442: 1716 missing values generated
        a443: 1716 missing values generated
        a444: 1716 missing values generated
        a445: 1716 missing values generated
        a446: 1716 missing values generated
        a447: 1716 missing values generated
        a448: 1716 missing values generated
        a449: 1716 missing values generated
        a450: 1716 missing values generated
        a451: 1716 missing values generated
        a452: 1733 missing values generated
        a453: 1738 missing values generated
        a454: 1742 missing values generated
        a701: 1716 missing values generated
        a702: 1716 missing values generated
        a703: 1716 missing values generated
        a704: 1717 missing values generated
        a705: 1719 missing values generated
        a706: 1717 missing values generated
        a707: 1716 missing values generated
        a708: 1716 missing values generated
        a709: 1716 missing values generated
        a710: 1720 missing values generated
        a711: 1736 missing values generated
        a712: 1724 missing values generated
        a713: 1761 missing values generated
        a714: 1805 missing values generated
        a715: 1780 missing values generated
        a716: 1717 missing values generated
        a717: 1721 missing values generated
        a718: 1717 missing values generated
        a719: 1719 missing values generated
        a720: 1733 missing values generated
        a721: 1722 missing values generated
        a722: 1716 missing values generated
        a723: 1716 missing values generated
        a724: 1716 missing values generated
        a725: 1731 missing values generated
        a726: 1752 missing values generated
        a727: 1740 missing values generated
        a728: 1725 missing values generated
        a729: 1739 missing values generated
        a730: 1730 missing values generated
        a731: 1716 missing values generated
        a732: 1716 missing values generated
        a733: 1717 missing values generated
        a734: 1725 missing values generated
        a735: 1741 missing values generated
        a736: 1729 missing values generated
        a737: 1741 missing values generated
        a738: 1765 missing values generated
        a739: 1748 missing values generated
        a740: 1732 missing values generated
        a741: 1754 missing values generated
        a742: 1741 missing values generated
        a743: 1718 missing values generated
        a744: 1723 missing values generated
        a745: 1719 missing values generated
        a746: 1827 missing values generated
        a747: 1890 missing values generated
        a748: 1841 missing values generated
        a749: 1919 missing values generated
        a750: 1955 missing values generated
        a751: 1938 missing values generated
        a752: 1779 missing values generated
        a753: 1852 missing values generated
        a754: 1783 missing values generated
        a755: 1774 missing values generated
        a756: 1817 missing values generated
        a757: 1784 missing values generated
        a758: 1825 missing values generated
        a759: 1887 missing values generated
        a760: 1840 missing values generated
        a761: 1866 missing values generated
        a762: 1922 missing values generated
        a763: 1876 missing values generated
        a764: 1767 missing values generated
        a765: 1789 missing values generated
        a766: 1794 missing values generated
        a767: 1807 missing values generated
        a768: 1845 missing values generated
        a769: 1820 missing values generated
        a770: 1865 missing values generated
        a771: 1931 missing values generated
        a772: 1875 missing values generated
        a773: 1793 missing values generated
        a774: 1840 missing values generated
        a775: 1812 missing values generated
        a776: 1916 missing values generated
        a777: 1943 missing values generated
        a778: 1934 missing values generated
        a779: 1819 missing values generated
        a780: 1871 missing values generated
        a781: 1835 missing values generated
        a782: 1925 missing values generated
        a783: 1972 missing values generated
        a784: 1931 missing values generated
        a785: 1961 missing values generated
        a786: 1972 missing values generated
        a787: 1970 missing values generated
        a788: 1788 missing values generated
        a789: 1836 missing values generated
        a790: 1805 missing values generated
        a791: 1856 missing values generated
        a792: 1887 missing values generated
        a793: 1869 missing values generated
        a794: 1836 missing values generated
        a795: 1886 missing values generated
        a796: 1854 missing values generated
        a797: 1848 missing values generated
        a798: 1901 missing values generated
        a799: 1869 missing values generated
        a800: 1921 missing values generated
        a801: 1971 missing values generated
        a802: 1925 missing values generated
        a803: 1921 missing values generated
        a804: 1964 missing values generated
        a805: 1932 missing values generated
        a806: 1890 missing values generated
        a807: 1934 missing values generated
        a808: 1902 missing values generated
        a809: 1847 missing values generated
        a810: 1879 missing values generated
        a811: 1876 missing values generated
        a812: 1789 missing values generated
        a813: 1824 missing values generated
        a814: 1798 missing values generated
        a815: 1960 missing values generated
        a816: 1985 missing values generated
        a817: 1967 missing values generated
        a818: 1918 missing values generated
        a819: 1956 missing values generated
        a820: 1934 missing values generated
        a821: 1992 missing values generated
        a822: 1994 missing values generated
        a823: 1999 missing values generated
        a824: 1956 missing values generated
        a825: 1987 missing values generated
        a826: 1958 missing values generated
        a827: 1987 missing values generated
        a828: 1994 missing values generated
        a829: 1991 missing values generated
        a830: 1899 missing values generated
        a831: 1933 missing values generated
        a832: 1908 missing values generated
        a833: 1939 missing values generated
        a834: 1957 missing values generated
        a835: 1947 missing values generated
        a836: 1977 missing values generated
        a837: 1992 missing values generated
        a838: 1981 missing values generated
        a839: 1977 missing values generated
        a840: 1988 missing values generated
        a841: 1980 missing values generated
        a842: 1964 missing values generated
        a843: 1980 missing values generated
        a844: 1967 missing values generated
        a845: 1875 missing values generated
        a846: 1921 missing values generated
        a847: 1893 missing values generated
        a848: 1975 missing values generated
        a849: 1986 missing values generated
        a850: 1984 missing values generated
        a851: 1948 missing values generated
        a852: 1982 missing values generated
        a853: 1951 missing values generated
        a854: 1936 missing values generated
        a855: 1961 missing values generated
        a856: 1945 missing values generated
        a857: 1948 missing values generated
        a858: 1971 missing values generated
        a859: 1950 missing values generated
        a860: 1978 missing values generated
        a861: 1990 missing values generated
        a862: 1980 missing values generated
        a863: 1974 missing values generated
        a864: 1992 missing values generated
        a865: 1977 missing values generated
        a866: 1973 missing values generated
        a867: 1988 missing values generated
        a868: 1975 missing values generated
        a869: 1825 missing values generated
        a870: 1859 missing values generated
        a871: 1840 missing values generated
        a872: 1832 missing values generated
        a873: 1924 missing values generated
        a874: 1838 missing values generated
  asset_g_qz: 1876 missing values generated
  asset_n_qz: 1092 missing values generated

. drop if city05==.
(0 observations deleted)

. 
. *** Indicator for a prefecture boundary change
. gen chg = (obs>1)

. drop obs

. 
. *** Label Variables
. label variable gdp "(ind yrb)"

. label variable nnp "(ind yrb)"

. label variable gdp_sector1 "(ind yrb)"

. label variable nnp_sector1 "(ind yrb)"

. label variable gdp_sector2 "(ind yrb)"

. label variable nnp_sector2 "(ind yrb)"

. label variable gdp_sector3 "(ind yrb)"

. label variable nnp_sector3 "(ind yrb)"

. label variable tot_pop "(ind yrb)"

. label variable r08_gdp "(ind yrb)"

. label variable r08_nnp "(ind yrb)"

. label variable r08_gdp_sector2 "(ind yrb)"

. label variable r08_nnp_sector2 "(ind yrb)"

. label variable r08_gdp_sector3 "(ind yrb)"

. label variable r08_nnp_sector3 "(ind yrb)"

. label variable r08_tot_pop "(ind yrb)"

. label variable num_car "(ind yrb)"

. label variable dust_ems "(ind yrb)"

. label variable gas_ems "(ind yrb)"

. label variable so2 "(ind yrb)"

. label variable kproad "(ind yrb)"

. label variable aproad "(ind yrb)"

. label variable bustrly "(ind yrb)"

. label variable numhins "(ind yrb)"

. label variable arrived_fdi "(ind yrb)"

. label variable tot_emp "(ind yrb)"

. label variable tot_emp_sect2 "(ind yrb)"

. label variable tot_emp_sect3 "(ind yrb)"

. label variable giov "(ind yrb)"

. label variable giov_soecol "(ind yrb)"

. label variable tot_area "(ind yrb)"

. label variable giov_new "(ind yrb)"

. label variable giov_soecol_new "(ind yrb)"

. label variable totemp "(py)"

. label variable agremp "(py)"

. label variable minemp "(py)"

. label variable manuemp "(py)"

. label variable egwemp "(py)"

. label variable constemp "(py)"

. label variable geolemp "(py)"

. label variable tstemp "(py)"

. label variable whoreemp "(py)"

. label variable fininsemp "(py)"

. label variable reemp "(py)"

. label variable ssemp "(py)"

. label variable hsemp "(py)"

. label variable ecmemp "(py)"

. label variable stemp "(py)"

. label variable pubemp "(py)"

. label variable gdp_py "(py adjusted with predicted when necessary)"

. label variable gdp_sect2 "(py adjusted with predicted when necessary)"

. label variable gdp_sect3 "(py)"

. label variable total_pop "(py)"

. label variable kmpr "(py)"

. label variable apr "(py)"

. label variable prpc "(py)"

. label variable num_bt "(py)"

. label variable so2 "(py)"

. label variable avgsalary "(py)"

. label variable num_colstd "(py)"

. label variable givo "(py)"

. label variable givo_soe "(py)"

. label variable givo_colt "(py)"

. label variable exp_lgt "(py)"

. label variable num_hedu "(py)"

. label variable publibcol "(py)"

. label variable culland "(py+fenxian)"

. label variable area "(py)"

. label variable emp_sect2 "(py)"

. label variable emp_sect3 "(py)"

. label variable fixinvest "(py)"

. label variable fdi "(py)"

. label variable chg "1 if prefecture changed boundaries"

. label variable a101 "Total no. of H                                            T
> able 2-19"

. label variable a102 "Total P                                                    
>         "

. label variable a103 "Total M                                   H=household(s)   
>         "

. label variable a104 "Total F                                   M=male(s)        
>         "

. label variable a105 "Residents of urban wards: No. of H        F=female(s)      
>         "

. label variable a106 "                     : P               P=population (M+F)  
>      "

. label variable a107 "                     : M                                   
>      "

. label variable a108 "                     : F                                   
>      "

. label variable a109 "Residents of villages: No. of H                            
>         "

. label variable a110 "                  : P                                      
>      "

. label variable a111 "                  : M                                      
>      "

. label variable a112 "                  : F                                      
>      "

. label variable a113 "Residents of rural units outside village jurisdiction: No. 
> of H    "

. label variable a114 "                                                  : P      
>      "

. label variable a115 "                                                  : M      
>      "

. label variable a116 "                                                  : F      
>      "

. label variable a117 "Non-agricultural H: P                                      
>         "

. label variable a118 "               : M                                         
>      "

. label variable a119 "               : F                                         
>      "

. label variable a120 "Agricultural H: P                                          
>         "

. label variable a121 "           : M                                             
>      "

. label variable a122 "           : F                                             
>      "

. label variable a123 "Specially designated H and persons outside any H: P        
>         "

. label variable a124 "                                             : M           
>      "

. label variable a125 "                                             : F           
>      "

. label variable a126 "All residents of all zhen (townships) combined: No. of H  T
> able 2-11"

. label variable a127 "                                       : P                 
>  "

. label variable a128 "                                       : M                 
>  "

. label variable a129 "                                       : F                 
>  "

. label variable a130 "Town residents in all zhen combined: No. of H              
>         "

. label variable a131 "                                 : P                       
>       "

. label variable a132 "                                 : M                       
>       "

. label variable a133 "                                 : F                       
>       "

. label variable a134 "Rural residents in all zhen combined: No. of H             
>         "

. label variable a135 "                                  : P                      
>       "

. label variable a136 "                                  : M                      
>       "

. label variable a137 "                                  : F                      
>       "

. label variable a138 "Non-agricultural H in all zhen combined: P                T
> able 2-12"

. label variable a139 "                                     : M                   
>       "

. label variable a140 "                                     : F                   
>       "

. label variable a141 "Agricultural H in all zhen combined: P                     
>         "

. label variable a142 "                              : M                          
>    "

. label variable a143 "                           : F                             
>    "

. label variable a144 "Specially designated H, etc. in all zhen combined: P       
>         "

. label variable a145 "                                            : M            
>    "

. label variable a146 "                                            : F            
>    "

. label variable a181 "Total P, all ages and both sexes                           
>          A1"

. label variable a182 "Total M, all ages                                          
>          A2"

. label variable a183 "Total F, all ages                                          
>          A3"

. label variable a184 "P 0-4                                                      
>          A4"

. label variable a185 "M 0-4                                                      
>          A5"

. label variable a186 "F 0-4                                                      
>          A6"

. label variable a187 "P 5-9                                                      
>          A7"

. label variable a188 "M 5-9                                                      
>          A8"

. label variable a189 "F 5-9                                                      
>          A9"

. label variable a190 "P 10-14                                                    
>         A10"

. label variable a191 "M 10-14                                                    
>         A11"

. label variable a192 "F 10-14                                                    
>         A12"

. label variable a193 "P 15-19                                                    
>         A13"

. label variable a194 "M 15-19                                                    
>         A14"

. label variable a195 "F 15-19                                                    
>         A15"

. label variable a196 "P 20-24                                                    
>         A16"

. label variable a197 "M 20-24                                                    
>         A17"

. label variable a198 "F 20-24                                                    
>         A18"

. label variable a199 "P 25-29                                                    
>         A19"

. label variable a200 "M 25-29                                                    
>         A20"

. label variable a201 "F 25-29                                                    
>         A21"

. label variable a202 "P 30-34                                                    
>         A22"

. label variable a203 "M 30-34                                                    
>         A23"

. label variable a204 "F 30-34                                                    
>         A24"

. label variable a205 "P 35-39                                                    
>         A25"

. label variable a206 "M 35-39                                                    
>         A26"

. label variable a207 "F 35-39                                                    
>         A27"

. label variable a208 "P 40-44                                                    
>         A28"

. label variable a209 "M 40-44                                                    
>         A29"

. label variable a210 "F 40-44                                                    
>         A30"

. label variable a211 "P 45-49                                                    
>         A31"

. label variable a212 "M 45-49                                                    
>         A32"

. label variable a213 "F 45-49                                                    
>         A33"

. label variable a214 "P 50-54                                                    
>         A34"

. label variable a215 "M 50-54                                                    
>         A35"

. label variable a216 "F 50-54                                                    
>         A36"

. label variable a217 "P 55-59                                                    
>         A37"

. label variable a218 "M 55-59                                                    
>         A38"

. label variable a219 "F 55-59                                                    
>         A39"

. label variable a220 "P 60-64                                                    
>         A40"

. label variable a221 "M 60-64                                                    
>         A41"

. label variable a222 "F 60-64                                                    
>         A42"

. label variable a223 "P 65-69                                                    
>         A43"

. label variable a224 "M 65-69                                                    
>         A44"

. label variable a225 "F 65-69                                                    
>         A45"

. label variable a226 "P 70-74                                                    
>         A46"

. label variable a227 "M 70-74                                                    
>         A47"

. label variable a228 "F 70-74                                                    
>         A48"

. label variable a229 "P 75-79                                                    
>         A49"

. label variable a230 "M 75-79                                                    
>         A50"

. label variable a231 "F 75-79                                                    
>         A51"

. label variable a232 "P 80-84                                                    
>         A52"

. label variable a233 "M 80-84                                                    
>         A53"

. label variable a234 "F 80-84                                                    
>         A54"

. label variable a235 "P 85-89                                                    
>         A55"

. label variable a236 "M 85-89                                                    
>         A56"

. label variable a237 "F 85-89                                                    
>         A57"

. label variable a238 "P 90-94                                                    
>         A58"

. label variable a239 "M 90-94                                                    
>         A59"

. label variable a240 "F 90-94                                                    
>         A60"

. label variable a241 "P 95-99                                                    
>         A61"

. label variable a242 "M 95-99                                                    
>         A62"

. label variable a243 "F 95-99                                                    
>         A63"

. label variable a244 "P 100+                                                     
>         A64"

. label variable a245 "M 100+                                                     
>         A65"

. label variable a246 "F 100+                                                     
>         A66"

. label variable a261 "Total P aged 6+                                            
>          E1"

. label variable a262 "Total M aged 6+                                            
>          E2"

. label variable a263 "Total F aged 6+                                            
>          E3"

. label variable a264 "P university                                               
>          E4"

. label variable a265 "M                                                          
>          E5"

. label variable a266 "F                                                          
>          E6"

. label variable a267 "P technical/junior college                                 
>          E7"

. label variable a268 "M                                                          
>          E8"

. label variable a269 "F                                                          
>          E9"

. label variable a270 "P secondary technical school                               
>         E10"

. label variable a271 "M                                                          
>         E11"

. label variable a272 "F                                                          
>         E12"

. label variable a273 "P senior middle school                                     
>         E13"

. label variable a274 "M                                                          
>         E14"

. label variable a275 "F                                                          
>         E15"

. label variable a276 "P junior middle school                                     
>         E16"

. label variable a277 "M                                                          
>         E17"

. label variable a278 "F                                                          
>         E18"

. label variable a279 "P primary school                                           
>         E19"

. label variable a280 "M                                                          
>         E20"

. label variable a281 "F                                                          
>         E21"

. label variable a282 "P illiterate/semi-illiterate                               
>         E22"

. label variable a283 "M                                                          
>         E23"

. label variable a284 "F                                                          
>         E24"

. label variable a291 "Total P 15+                                                
>          E1"

. label variable a292 "Total M 15+                                                
>          E2"

. label variable a293 "Total F 15+                                                
>          E3"

. label variable a294 "P illiterate/semi-illiterate                               
>          E4"

. label variable a295 "M                                                          
>          E5"

. label variable a296 "F                                                          
>          E6"

. label variable a301 "Total P 15+                                                
>          M1"

. label variable a302 "Total M 15+                                                
>          M2"

. label variable a303 "Total F 15+                                                
>          M3"

. label variable a304 "P never married                                            
>          M4"

. label variable a305 "M                                                          
>          M5"

. label variable a306 "F                                                          
>          M6"

. label variable a307 "P married                                                  
>          M7"

. label variable a308 "M                                                          
>          M8"

. label variable a309 "F                                                          
>          M9"

. label variable a310 "P widowed                                                  
>         M10"

. label variable a311 "M                                                          
>         M11"

. label variable a312 "F                                                          
>         M12"

. label variable a313 "P divorced                                                 
>         M13"

. label variable a314 "M                                                          
>         M14"

. label variable a315 "F                                                          
>         M15"

. label variable a321 "All births 1Jan89-30Jun90                                  
>          B1"

. label variable a322 "M births                                                   
>          B2"

. label variable a323 "F births                                                   
>          B3"

. label variable a324 "All births 1Jan89-30Jun89                                  
>          B4"

. label variable a325 "M births                                                   
>          B5"

. label variable a326 "F births                                                   
>          B6"

. label variable a327 "All births 1Jul89-31Dec89                                  
>          B7"

. label variable a328 "M births                                                   
>          B8"

. label variable a329 "F births                                                   
>          B9"

. label variable a330 "All births 1Jan90-30Jun90                                  
>         B10"

. label variable a331 "M births                                                   
>         B11"

. label variable a332 "F births                                                   
>         B12"

. label variable a341 "All deaths 1Jan89-30Jun90                                  
>          D1"

. label variable a342 "M deaths                                                   
>          D2"

. label variable a343 "F deaths                                                   
>          D3"

. label variable a344 "All deaths 1Jan89-30Jun89                                  
>          D4"

. label variable a345 "M deaths                                                   
>          D5"

. label variable a346 "F deaths                                                   
>          D6"

. label variable a347 "All deaths 1Jul89-31Dec89                                  
>          D7"

. label variable a348 "M deaths                                                   
>          D8"

. label variable a349 "F deaths                                                   
>          D9"

. label variable a350 "All deaths 1Jan90-30Jun90                                  
>         D10"

. label variable a351 "M deaths                                                   
>         D11"

. label variable a352 "F deaths                                                   
>         D12"

. label variable a361 "Total inmigrants                                           
>          R1"

. label variable a362 "Within-province inmigrants: Total                          
>          R2"

. label variable a363 "                       : from municipal cities             
>       R3"

. label variable a364 "                       : from zhen (urban townships)       
>       R4"

. label variable a365 "                       : from xiang (rural townships)      
>       R5"

. label variable a366 "Inmigrants from other provinces: Total                     
>          R6"

. label variable a367 "                         : from municipal cities           
>       R7"

. label variable a368 "                         : from zhen                       
>       R8"

. label variable a369 "                         : from xiang                      
>       R9"

. label variable a370 "Other inmigrants                                           
>         R10"

. label variable a381 "Total employed P                                           
>          I1"

. label variable a382 "Total          M                                           
>          I2"

. label variable a383 "Total          F                                           
>          I3"

. label variable a384 "P Agric./forestry/animal husb./fishery/water conservancy   
>          I4"

. label variable a385 "M                                                          
>          I5"

. label variable a386 "F                                                          
>          I6"

. label variable a387 "P Industry                                                 
>          I7"

. label variable a388 "M                                                          
>          I8"

. label variable a389 "F                                                          
>          I9"

. label variable a390 "P Mining, prospecting                                      
>         I10"

. label variable a391 "M                                                          
>         I11"

. label variable a392 "F                                                          
>         I12"

. label variable a393 "P Construction                                             
>         I13"

. label variable a394 "M                                                          
>         I14"

. label variable a395 "F                                                          
>         I15"

. label variable a396 "P Transport, posts, telecommunications                     
>         I16"

. label variable a397 "M                                                          
>         I17"

. label variable a398 "F                                                          
>         I18"

. label variable a399 "P Commerce, supply and marketing                           
>         I19"

. label variable a400 "M                                                          
>         I20"

. label variable a401 "F                                                          
>         I21"

. label variable a402 "P Real estate, utilities, residential services             
>         I22"

. label variable a403 "M                                                          
>         I23"

. label variable a404 "F                                                          
>         I24"

. label variable a405 "P Medicine, health care, sports, welfare                   
>         I25"

. label variable a406 "M                                                          
>         I26"

. label variable a407 "F                                                          
>         I27"

. label variable a408 "P Education, culture, arts, radio, television              
>         I28"

. label variable a409 "M                                                          
>         I29"

. label variable a410 "F                                                          
>         I30"

. label variable a411 "P Science, technology                                      
>         I31"

. label variable a412 "M                                                          
>         I32"

. label variable a413 "F                                                          
>         I33"

. label variable a414 "P Finance, insurance                                       
>         I34"

. label variable a415 "M                                                          
>         I35"

. label variable a416 "F                                                          
>         I36"

. label variable a417 "P Government, party, and NGOs                              
>         I37"

. label variable a418 "M                                                          
>         I38"

. label variable a419 "F                                                          
>         I39"

. label variable a420 "P Other economic activities                                
>         I40"

. label variable a421 "M                                                          
>         I41"

. label variable a422 "F                                                          
>         I42"

. label variable a431 "P Professional and high-level technical personnel          
>          O1"

. label variable a432 "M                                                          
>          O2"

. label variable a433 "F                                                          
>          O3"

. label variable a434 "P Officials/managers in gov't, party, business, & NGOs     
>          O4"

. label variable a435 "M                                                          
>          O5"

. label variable a436 "F                                                          
>          O6"

. label variable a437 "P Clerical personnel                                       
>          O7"

. label variable a438 "M                                                          
>          O8"

. label variable a439 "F                                                          
>          O9"

. label variable a440 "P Employees in commercial sector                           
>         O10"

. label variable a441 "M                                                          
>         O11"

. label variable a442 "F                                                          
>         O12"

. label variable a443 "P Employees in service sector                              
>         O13"

. label variable a444 "M                                                          
>         O14"

. label variable a445 "F                                                          
>         O15"

. label variable a446 "P Workers in agric., forestry, animal husb., fisheries     
>         O16"

. label variable a447 "M                                                          
>         O17"

. label variable a448 "F                                                          
>         O18"

. label variable a449 "P Workers in manufacturing, construction, transport, etc.  
>         O19"

. label variable a450 "M                                                          
>         O20"

. label variable a451 "F                                                          
>         O21"

. label variable a452 "P Other and misc. occupations                              
>         O22"

. label variable a453 "M                                                          
>         O23"

. label variable a454 "F                                                          
>         024"

. label variable a701 "P Han Chinese"

. label variable a702 "M        "

. label variable a703 "F        "

. label variable a704 "P Mongol (Menggu) minority"

. label variable a705 "M        "

. label variable a706 "F        "

. label variable a707 "P Hui minority"

. label variable a708 "M        "

. label variable a709 "F        "

. label variable a710 "P Tibetan (Zang) minority"

. label variable a711 "M        "

. label variable a712 "F        "

. label variable a713 "P Uygur (Weiwu`er) minority"

. label variable a714 "M        "

. label variable a715 "F        "

. label variable a716 "P Miao minority"

. label variable a717 "M        "

. label variable a718 "F        "

. label variable a719 "P Yi minority"

. label variable a720 "M        "

. label variable a721 "F        "

. label variable a722 "P Zhuang minority"

. label variable a723 "M        "

. label variable a724 "F        "

. label variable a725 "P Bouyei (Buyi) minority"

. label variable a726 "M        "

. label variable a727 "F        "

. label variable a728 "P Korean (Chaoxian) minority"

. label variable a729 "M        "

. label variable a730 "F        "

. label variable a731 "P Manchu (Man) minority"

. label variable a732 "M        "

. label variable a733 "F        "

. label variable a734 "P Dong minority"

. label variable a735 "M        "

. label variable a736 "F        "

. label variable a737 "P Yao minority"

. label variable a738 "M        "

. label variable a739 "F        "

. label variable a740 "P Bai minority"

. label variable a741 "M        "

. label variable a742 "F        "

. label variable a743 "P Tujia minority"

. label variable a744 "M        "

. label variable a745 "F        "

. label variable a746 "P Hani minority"

. label variable a747 "M        "

. label variable a748 "F        "

. label variable a749 "P Kazak (Hasake) minority"

. label variable a750 "M        "

. label variable a751 "F        "

. label variable a752 "P Dai minority"

. label variable a753 "M        "

. label variable a754 "F        "

. label variable a755 "P Li minority"

. label variable a756 "M        "

. label variable a757 "F        "

. label variable a758 "P Lisu minority"

. label variable a759 "M        "

. label variable a760 "F        "

. label variable a761 "P Va (Wa) minority"

. label variable a762 "M        "

. label variable a763 "F        "

. label variable a764 "P She minority"

. label variable a765 "M        "

. label variable a766 "F        "

. label variable a767 "P Gaoshan minority"

. label variable a768 "M        "

. label variable a769 "F        "

. label variable a770 "P Lahu minority"

. label variable a771 "M        "

. label variable a772 "F        "

. label variable a773 "P Shui minority"

. label variable a774 "M        "

. label variable a775 "F        "

. label variable a776 "P Dongxiang minority"

. label variable a777 "M        "

. label variable a778 "F        "

. label variable a779 "P Naxi minority"

. label variable a780 "M        "

. label variable a781 "F        "

. label variable a782 "P Jingpo minority"

. label variable a783 "M        "

. label variable a784 "F        "

. label variable a785 "P Kirgiz (Ke`erkezi) minority"

. label variable a786 "M        "

. label variable a787 "F        "

. label variable a788 "P Tu minority"

. label variable a789 "M        "

. label variable a790 "F        "

. label variable a791 "P Daur (Dawo`er) minority"

. label variable a792 "M        "

. label variable a793 "F        "

. label variable a794 "P Mulam (Mulao) minority"

. label variable a795 "M        "

. label variable a796 "F        "

. label variable a797 "P Qiang minority"

. label variable a798 "M        "

. label variable a799 "F        "

. label variable a800 "P Blang (Bulang) minority"

. label variable a801 "M        "

. label variable a802 "F        "

. label variable a803 "P Salar (Sala) minority"

. label variable a804 "M        "

. label variable a805 "F        "

. label variable a806 "P Maonan minority"

. label variable a807 "M        "

. label variable a808 "F        "

. label variable a809 "P Gelo (Gelao) minority"

. label variable a810 "M        "

. label variable a811 "F        "

. label variable a812 "P Xibe (Xibo) minority"

. label variable a813 "M        "

. label variable a814 "F        "

. label variable a815 "P Achang minority"

. label variable a816 "M        "

. label variable a817 "F        "

. label variable a818 "P Pumi minority"

. label variable a819 "M        "

. label variable a820 "F        "

. label variable a821 "P Tajik (Tajike) minority"

. label variable a822 "M        "

. label variable a823 "F        "

. label variable a824 "P Nu minority"

. label variable a825 "M        "

. label variable a826 "F        "

. label variable a827 "P Uzbek (Wuzibieke) minority"

. label variable a828 "M        "

. label variable a829 "F        "

. label variable a830 "P Russian (Eluosi) minority"

. label variable a831 "M        "

. label variable a832 "F        "

. label variable a833 "P Ewenki (Ewenke) minority"

. label variable a834 "M        "

. label variable a835 "F        "

. label variable a836 "P De'ang minority"

. label variable a837 "M        "

. label variable a838 "F        "

. label variable a839 "P Bonan (Bao`an) minority"

. label variable a840 "M        "

. label variable a841 "F        "

. label variable a842 "P Yugur (Yugu) minority"

. label variable a843 "M        "

. label variable a844 "F        "

. label variable a845 "P Jing minority"

. label variable a846 "M        "

. label variable a847 "F        "

. label variable a848 "P Tatar (Tata`er) minority"

. label variable a849 "M        "

. label variable a850 "F        "

. label variable a851 "P Drung (Dulong) minority"

. label variable a852 "M        "

. label variable a853 "F        "

. label variable a854 "P Oroqen (Elunchun) minority"

. label variable a855 "M        "

. label variable a856 "F        "

. label variable a857 "P Hezhen (Hezhe) minority"

. label variable a858 "M        "

. label variable a859 "F        "

. label variable a860 "P Monba (Menba) minority"

. label variable a861 "M        "

. label variable a862 "F        "

. label variable a863 "P Lhopa (Luoba) minority"

. label variable a864 "M        "

. label variable a865 "F        "

. label variable a866 "P Jinuo minority"

. label variable a867 "M        "

. label variable a868 "F        "

. label variable a869 "P nationality/ethnicity unknown"

. label variable a870 "M                                     "

. label variable a871 "F                                     "

. label variable a872 "P naturalized citizens"

. label variable a873 "M                       "

. label variable a874 "F                       "

. label variable asset_g_qz "gross asset value (QZ)"

. label variable asset_n_qz "net asset value (QZ)"

. 
. sort city05 year

. save ..\..\data\tabular_data_BJ\generated\pft.dta, replace
file ..\..\data\tabular_data_BJ\generated\pft.dta saved

. 
. log close
      name:  <unnamed>
       log:  C:\research\china\decentralization\restat_data\tabdata\dofiles\tab_da
> ta\tabdata5.log
  log type:  text
 closed on:  22 Jul 2016, 09:51:34
----------------------------------------------------------------------------------
